SELECT 'DELETE FROM ' + UPPER(obj.name) FROM  sysobjects obj 
where xtype = 'u' and obj.name <> 'sys_lov' and obj.name <> 'sys_setting'
order by obj.name


alter proc gettables
as
SELECT obj.name FROM  sysobjects obj 
where xtype = 'u' and obj.name not in('companyinfo','personinfo')
order by obj.name

SELECT obj.name,null as notes FROM  sysobjects obj 
where xtype = 'u' and obj.name not in('companyinfo','personinfo')
order by obj.name



